package com.geostar.constructionland.analyse.mapper.adjust;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 *
 */
public interface AdjustMapper extends BaseMapper {
    /**
     * 获取地块原始面积
     * @return
     */
    @Select(" select sum(dkmj_ys) dkmj from jsyd_dkxx where kcdjid in (select kcdjid from jsyd_xmdkgx where ywid=#{ywid}) ")
    double getDkYsMj(@Param("ywid")String ywid);

    @Select(" select sum(zymj) zymj from jsyd_fx_dlfx_tj_tzh where fxbs = #{fxbs} ")
    double getAdjustedDlfxMj(@Param("fxbs")String fxbs);
}
